2016-05-16 - 26997 - Spec - Enable Payee Positive Pay functions #FIOutgoingpayments #FIAP
SPECIFICATIONS
26997-Spec-Enable Payee Positive Pay functions
Purpose
Enable Payee Positive Pay functions in order to eliminate frauds for printed checks in US
Admin Info
| Purpose |
Enable Payee Positive Pay functions |
| Requested By |
Baiwa |
| Spec Created By |
Raghav |
| Spec Created Date |
05/16/2016 |
| Spec QA by |
Raghav |
| Objects |
ZRFCHKE00 ZFCHX VC_BANKDET ZFI_PPPUPLOAD_ENCASH ZFI_PPP ZRFEBCK00 |
| Document Status |
Completed |
Estimates
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
16 |
| 2 |
Documentation |
05 |
| 3 |
Development/ Config |
30 |
| 4 |
Unit test in DEV |
30 |
| 5 |
Unit test in QUA |
10 |
| 6 |
Other activity |
|
| TOTAL |
91 |
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]Documents
[Attach any document(s) received for the requirement(s)]Positive Pay File Definition.docxoutput format with indicators(Inbound file).docARP Input-Output.pdf
Technical Walkthrough - Payee Positive Pay.pptxInbound process flow.docx
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
| Sl. |
Change Details |
Requested By |
Requested On |
Notes if any |
| 1 |
New conversion file for inbound encashment file from M&T bank as the SAP standard will not accept the bank encashment file. |
Baiwa |
07/04/2016 |
|
| 2 |
Add file name and include void checks in outbound file |
Baiwa |
07/22/2016 |
|
| 3 |
New change in encashment file with output format indicators |
Baiwa |
08/18/2016 |
|
| 4 |
Background log to show the info of all cancelled checks at conversion time |
Baiwa |
08/18/2016 |
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]Enable Payee Positive Pay functions in order to eliminate frauds for printed checks in US
In Scope:
[List the activities to be included in scope]Out of Scope:
[Out of scope activities]Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
1) Outbound Process
Positive pay file should contain the following fields by adding in the program RFCHKE00
Account number in position: 1 -15 Length of: 15
Check number: 16 -25 Length of: 10
Dollar Amount: 26-37 Length of: 12
Date: 38 – 45 YYYYMMDD Length of: 8
Record Indicator: 46 Length of: 1
Field will remain blank if not voiding an item. If item needs to be voided, they would place a Capital V
Blank Field: 47 Length of: 1
Field always remains blank
Payee: 48-100 Length of: 100
2) Inbound process
Develop new conversion encashment file to support SAP standard from the received bank encashment file as below.
Bank file- Will have only account number, check number and check amount with clearing date in encashment file.
NewEraCapRecon2.txt
As the NEC have the same account number in multiple company codes so put validations to pick the right bank and company code by giving input account number in table T012K and the check number in table PAYR
Step 1 - From the inbound file length(1-15) is the account number and exclude '0's before the number starts then pass in table T012K with preceding * and pick all available fields Company code, House Bank and Account ID entries.
Step 2 - Pick check number from inbound file length(16-25) and give the input in table PAYR with all fields Company code, House Bank and Account ID picked from table T012K then we will get one single entry to confirm the company code and house bank.
Step 3 - Get the bank key from the table T012 by passing the company code and house bank.
Step 4 - Convert the bank encashment file to SAP standard with the fields and length as mentioned below
| Header |
||
| Field |
Length |
Logic |
| Constant No. 1 |
1-4 |
Hard code value 1 |
| Company code |
5-9 |
T012k-BUKRS |
| Account ID |
10-19 |
T012k-HKTID |
| Bank key |
20-34 |
T012-BANKK |
| Account number |
35-63 |
T012K-BANKN |
| Currency |
64-66 |
T012K-WAERS |
| Item |
||
| Constant No. 5 |
1 |
Hard code value 5 |
| Paid Date |
2-9 |
Pick from input file YYYYMMDD |
| Check no. |
10-22 |
PAYR-CHECT |
| Amount |
23-33 |
Pick from input file with leading zeros |
| Issue Date |
59-66 |
Pick from input file YYYYMMDD |
Test Plan
[List test scenarios/cases to be executed here]1) Outbound process:-
Generate the positive pay outbound file
| Test ID |
Test Scenario |
Expected Results |
Actual Results |
| FI-001 |
Generate the US check for cocd 0010 |
Check form should display the Void statement under the M&T bank and amount should exclude the star marks |
Check form generated as expected with out any issues |
| FI-002 |
Outbound file to M&T |
Program should display the void check amount and date in outbound file |
Check outbount file generated as expected with out any issues |
| Test ID |
Test Scenario |
Expected Results |
Actual Results |
| FI-001 |
Generate the US check outbountfile with the new Z transacrion ZFCHX |
File should be in placed in AL11 with prefixed name NEWERAPP and company code and timestamp YYYYMMDDHHMMSS |
Name for the file is getting perfectly in new Z transaction ZFCHX NEWERAPPCOCDYYYYMMDDMMSS |
Encashment file conversion and posting to clearing.
| Test ID |
Test Scenario |
Expected Results |
Actual Results |
| FI-001 |
Convert the inbound bank file to SAP standard in program ZFI_PPPUPLOAD_ENCASH |
Inbound file should convert as per SAP standard and not cleared checks should display in job log |
Converting with out any issues and displaying the job log |
| FI-002 |
Post encashment for cleared checks in program ZRFEBCK00 |
Conversion encash file should do check encashment and post to the clearing account |
Check encashment done perfectly and posted to clearing |
Solution Details
[Provide complete technical details for configuration or programming here]
1.A new program ZFI_PPPUPLOAD_ENCASH is developed to get the bank account,Bank key,Account ID from the input text file reading from application server.
2.Reqiured fields are taken from PAYR and T012K tables,kept in text file and sent to the application server.
3.A new program ZRFEBCK00 is copied from standard program RFEBCK00 to get the details of posting log in the spool.
4.A new function module ZGET_BANK_ACCOUNT is copied from standard function module get_bank_account assigned to function group ZFI_PPP and added import parameters company_code and account id to read the values of input file.
Issues
[List Issues / Bugs identified in configuration or development]